package guoanmaker.operator.business.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.operator.business.model.PersonalFinanceProject;

public interface PersonalFinanceProjectRepository  extends JpaRepository<PersonalFinanceProject, String>, JpaSpecificationExecutor<PersonalFinanceProject>{

	@Query(nativeQuery=true,value="select * from t_personal_finance_project where id=:id")
	public  PersonalFinanceProject   findById(@Param("id")String id);
	public PersonalFinanceProject findByFinanceProjectNumberAndStatus(@Param("financeProjectNumber") String financeProjectNumber, @Param("status") Integer status);
}
